set Identity_insert [Database] on
go
insert into [Database](DatabaseId,DbType,Instance,Connection,AccessType) values(1,'SqlServer','.','Data Source={0}\;Initial Catalog={1};Integrated Security=True;Pooling=False','System.Data.SqlClient');
go
set Identity_insert [Database] off
go

set Identity_insert FileStorage on
go
insert into [FileStorage](FileStorageId,StorageType,Location) values(1,'Local','E:\SiteDataFiles\Ruandao');
go
set Identity_insert FileStorage off
go

insert into [Site](SiteGuid,SiteName,Title,Description,OwnerGuid,UserLevel,CreateDate,DatabaseId,FoundationDbName,FileStorageId) values('4683f9d1-2df3-4460-9d15-eda61d51fa11','localhost','LOCAL HOST',null,'4683f9d1-2df3-4460-9d15-eda61d51fa11','Normal','2012/4/1 0:00:00',1,'RuandaoFoundation',1);
insert into [Site](SiteGuid,SiteName,Title,Description,OwnerGuid,UserLevel,CreateDate,DatabaseId,FoundationDbName,FileStorageId) values('4683f9d1-2df3-4460-9d15-eda61d51fa22','demo1','DEMO ONE',null,'4683f9d1-2df3-4460-9d15-eda61d51fa22','Normal','2012/4/1 0:00:00',1,'RuandaoFoundation',1);
insert into [Site](SiteGuid,SiteName,Title,Description,OwnerGuid,UserLevel,CreateDate,DatabaseId,FoundationDbName,FileStorageId) values('4683f9d1-2df3-4460-9d15-eda61d51fa33','demo2','DEMO TWO',null,'4683f9d1-2df3-4460-9d15-eda61d51fa33','Normal','2012/4/1 0:00:00',1,'RuandaoFoundation',1);
go

set Identity_insert [Domain] on
go
insert into [Domain](DomainId,DomainName,SiteGuid) values(1,'localhost','4683f9d1-2df3-4460-9d15-eda61d51fa11');
insert into [Domain](DomainId,DomainName,SiteGuid) values(2,'demo1','4683f9d1-2df3-4460-9d15-eda61d51fa22');
insert into [Domain](DomainId,DomainName,SiteGuid) values(3,'demo2','4683f9d1-2df3-4460-9d15-eda61d51fa33');
go
set Identity_insert [Domain] off
go
